Re: SMP-PPC spinlocks in 7.2.4? - Mailing list pgsql-general

From eric soroos
Subject Re: SMP-PPC spinlocks in 7.2.4?
Date
Msg-id 34769.1164577225@[4.42.179.151]
Whole thread Raw
In response to Re: SMP-PPC spinlocks in 7.2.4?  (eric soroos <eric-psql@soroos.net>)
Responses Re: SMP-PPC spinlocks in 7.2.4?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,

> > If you don't mind running a slightly customized version, you might try
> > back-patching this fix:
> > http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/async.c.diff?r1=1.91&r2=1.91.2.1
> > into 7.2.4 and see if that improves matters.
>
> I'll give that a shot.

It patched cleanly except for the version header. I've been running it for about 36 hours now with no problems. I'd say
thatI'm about 85% convinced that it made the difference, as I've also done some optimizations since then that reduce
thedatabase load by caching.  

I'd say that this patch is a candidate for 7.2.5 if there's ever another 7.2 release.

thanks for your help.

eric






pgsql-general by date:

Previous
From: Serkan Bektaþ
Date:
Subject: Re: Getting Started in Postgresql
Next
From: Tom Lane
Date:
Subject: Re: SMP-PPC spinlocks in 7.2.4?